{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Options","ShtSettings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":12,"defined_names":592,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Options","index":0,"n_rows":505,"n_cols":75,"rows_kept":505,"cut":false,"hidden":false,"merged":[[35,4,36,4],[28,5,28,6]]}
["National ENE"]
["National AENE"]
["National IYM"]
["National AFS"]
["National MTEC"]
["Entity ENE"]
["Entity MTEC"]
["Entity QTR"]
["Entity Budget Planning Baseline tool 2022"]
["Provincial EPRE"]
["Provincial MTEC"]
["Provincial IYM"]
["Provincial AFS"]
["Provincial AENE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Description  and details of Macro"]
[]
[null,null,"Purpose:",null,"To correct errors in the template"]
[null,null,"Sheets:",null,"Financial Position  and Sign Off"]
[null,null,"Template applicable to:",null,"Entity MTEC"]
[null,null,"Date of macro:",null,"2023/07/11"]
[null,null,"Effective until:",null,"N/A"]
[null,null,"Additional Information:",null,"This macro will make the following adjustments:\n","Precedent macros"]
[null,null,null,null,"1. Update the MTEF year from 2023 to 2024 in the sign-off.",1]
[null,null,null,null,"2. Rectify the checks for the carrying value of fixed assets in the financial position.",2]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]
[null,null,null,null,"This macro is only compatible with Excel 2007 or later",9]
[null,null,null,null,"Before using this macro make sure the following settings are applied:",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LEN(BB39)","v":0}]
[null,null,null,null,"For Excel 2007 and 2010 and 2013:",11]
[null,null,null,null,"1. Click \"File\" then \"Options\" or \"Excel Options\" (Excel 2007)",12]
[null,null,null,null,"2. In the next dialog box, click \"Trust Center\" then click \"Trust Center Settings…\"",13]
[null,null,null,null,"3. Choose \"Macro Settings\" and make sure the \"Trust access to the VBA project object model\" is selected.",14]
[null,null,null,null,null,15]
[null,null,null,null,null,16]
[]
[null,null,null,null,null,18]
[null,null,null,null,null,19]
[null,null,null,null,null,20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Rural Finance Corporation (Uvimba)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Coega Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Gambling and Betting Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Liquor Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Parks Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Tourism Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","East London Industrial Development Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Appropriate Technology Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Socio Economic Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Youth Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Mayibuye Transport Corp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EASTERN CAPE","Eastern Cape Provincial Arts Council"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State AgriEco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Centre for Citizenship Education "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Youth Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Mmabana Arts and Cultural Centre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Phakisa Major Sport Events and Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Gambling and Racing Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Investment Promotion Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Liquor Authority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FREE STATE","Free State Tourism Marketing Authority"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Blue IQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Development Economic Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Enterprise Propeller/GAUMAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Film Office"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Gambling Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Liquor Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Tourism Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAUTENG","Gauteng Youth Commission"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Ezemvelo KZN Wildlife"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Ithala Development Finance Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Mjindi Farming (Pty) Ltd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","KZN Tourism Authority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Natal Sharks Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","The Playhouse Company"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Provincial Planning and Development Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Umsekeli"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","Amafa aKwaZulu-Natali"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","KwaZulu-Natal Youth Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","KwaZulu-Natal Gambling Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KWAZULU-NATAL","KwaZulu-Natal Taxi Council"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","ARDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Entrepreneurial Support Centre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Gateway International Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","International Convention Centre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Limpopo Casino & Gaming Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Limpopo Developmental Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Limpopo Investment Initiative"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Limpopo Support Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Limpopo Tourism and Parks Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Local Business Service Centre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","SMME for African Ivory Route"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Trade Investment Limpopo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Polokwane International Airport"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPOPO","Road Agency Limpopo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Agricultural Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Economic Growth Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Gaming Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Tourism and Parks Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Zithabiseng Resort (Pty) Ltd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Regional Training Trust"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Housing Finance Company"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga House of Traditional Leaders"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPUMALANGA","Mpumalanga Youth Commission"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Directorate Entrepreneurial  Development - Agriserve "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","ESC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Gambling Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Invest North West"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Mafikeng Industrial Development Zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","North West Parks and Tourism Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","NW Development Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Provincial Council on Aids"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","North West Housing Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","North West Communications"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Youth Development Trust"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Mmabana Arts, Culture and Sport Foundation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTH WEST","Provincial Arts and Culture Council"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHERN CAPE","Northern Cape Tourism Authority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHERN CAPE","Northern Cape Gambling Public Entity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHERN CAPE","Northern Cape Liquor Public Entity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTHERN CAPE","Northern Cape Youth Commission"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Provincial Development Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Provincial Youth Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Casidra (Pty) Ltd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Independent Development Trust"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","South African Rail Commuter Corporation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Agricultural Research Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Council for Scientific and Industrial Research"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Destination Marketing Organisation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Investment and Trade Promotion Agency (Wesgro)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Liquor Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Artscape"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Cultural Commission"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Language Committee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Gambling and Racing Board"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Environmental Commissioner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WESTERN CAPE","Western Cape Nature Conservation Board"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[19690420]

{"sheet":"ShtSettings","index":1,"n_rows":166,"n_cols":6,"rows_kept":166,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"Completing the public entities' budget template"]
[]
[null,null,null,null,null,"This spread sheet is intended to assist the data compilers when completing the budget template to provide background on each sheet to be completed and some relevant notes on items to consider when preparing data for the budget.  Any changes effected on the template will be explained in the guidelines below: "]
[]
[null,null,null,null,null,"Changes effected on the template"]
[null,null,null,null,null,"Important general notes to consider"]
[null,null,null,null,null,"Admin and Objectives/Activities 2 to 10 contain the expenditure part of the Statement of Financial Performance as well as the Performance Indicators relating to each objective. Cells Q11-Q25 on all these Objectives/Activities contain a drop down to decide whether the performance indicators should be included in the Pub Table or not. Cells F45 - F92  contain a detailed goods and services list. The \"please specify\" rows have been removed from the expenditure sheets.  Instead there is a list  of goods and services items the entity can make use of to capture their expenditure.  In the event that the entity is of the view that the provided items do not cater fully to their expenditure type, they should contact the tecnnical assistance for further guidance\"."]
[]
[null,null,null,null,null,"Sheets: Revenue, Objectives, Cash Flow, Financial Position and infrastructure are prepopulated with data submitted in the previous budget process."]
[null,null,null,null,null,"New Column: Adjustments from Special Adjustments Budget"]
[null,null,null,null,null,"Sheets:  Revenue,Objectives,Cash flow and Financial position have a new column in 2021 named Adjustments from Special Adjustments Budget.  The column is applicable to entities whose budgets were affected by the Covid-19  Mini budget. The numbers might show an increase or decrease +/- depending on the impact on that specific entity."]
[null,null,null,null,null,"Revised budget column sums up the Approved Budget and the Adjustments from Special Adjustments budget columns."]
[null,null,null,null,null,"Changes from budget estimate Coulmn is the difference between Budget estimate and the Revised budget."]
[]
[null,null,null,null,null,"Navigation buttons on the left hand side of each sheet"]
[]
[null,null,null,null,null,"The Hide and Unhide Rows buttons are to be used to hide unused rows or unhide rows."]
[]
[null,null,null,null,null,"The Do's and Don'ts"]
[]
[null,null,null,null,null,"ONLY the darker blue-shaded areas are to be completed."]
[null,null,null,null,null,"All the white areas are FORMULA-DRIVEN and should NEVER be overwritten."]
[null,null,null,null,null,"The light blue areas are of DROP DOWN LISTS and should be used to select the relevant items from the list.  Entities should REFRAIN from copying data elsewhere and pasting it here."]
[null,null,null,null,null,"Column G in Financial Position, Cash Flow and Revenue sheets contain numbers that are of hyperlinks that navigate one to the definitions sheet for explanation of the specific item."]
[]
[null,null,null,null,null,"Information to understand about logistics of the template"]
[]
[null,null,null,null,null,"All sheets should contain information from the audited history years, the budget information for the current year and the budget projections for the MTEF years."]
[null,null,null,null,null,"The first year of history numbers that are pre-populated (e.g. for Revenue and Financial Position etc.) will be locked and no changes will be allowed unless there has been restatement of numbers. "]
[null,null,null,null,null,"The current year data (2020/21) and MTEF years' data may be revised where applicable and the outer year should be completed with data  i.e. 2023/24."]
[null,null,null,null,null,"The new column Adjustments from Special Adjustments Budget should also be completed with data where necessary "]
[null,null,null,null,null,"The template is prepopulated with budget 2020 data.  Entities should update the revised budget columns.  "]
[]
[null,null,null,null,null,"Analysis issues possible for queries if not attended to"]
[]
[null,null,null,null,null,"PFMA schedule 3A entities are NOT allowed to budget for deficit unless a prior approval has been granted to show deficits.  This will be queried if approval was not granted."]
[null,null,null,null,null,"Accumulated surplus/deficit line in the current year should reflect the increment or depletion of the balance by the surplus or deficit made by the entity in the Income Statement."]
[null,null,null,null,null,"The Cash and cash equivalents balance in the financial position should also reflect the movements of increases or decreases in the cash and cash equivalents shown on the Cash Flow Statement."]
[null,null,null,null,null,"Projections of interest revenue and interest expenses should be in line with the trends shown on projections for Investments/Cash and cash equivalents and Borrowings respectively."]
[null,null,null,null,null,"All highlighted trends on the TrendsAnalysis sheet should be explained in column S of the same sheet, else a query will be raised."]
[null,null,null,null,null,"All highlighted trends on the CashFlowDiff sheet should be explained in column O of the same sheet, else a query will be raised."]
[null,null,null,null,null,"Chronological order of sheets on the template"]
[]
[null,null,null,null,null,"The Blue Tabs - reference sheets"]
[]
[null,null,null,null,null,"Information sheet"]
[]
[null,null,null,null,null,"The purpose of this sheet is for the compiler to provide National Treasury with their contact details and to verify that the entity name is correct. The contact details of compilers are used for ease of reference when there are queries in the database.  Also contained on this sheet are the contact details of the Treasury Budget Examiner who should be contacted with regards to budget allocation issues  and the Technical Assistant who should be contacted with regards to complications on the template. The print sign-off  button is to be used to navigate to the sign-off sheet. The signed document must be printed and sent to the treasury."]
[]
[null,null,null,null,null,"Technical Guidelines"]
[]
[null,null,null,null,null,"The purpose of this sheet is to assist the data compiler with the background of each sheet to be completed and to provide some relevant notes on things to consider in preparing data for the template. This sheet should be read carefully for ease of completion of the template."]
[]
[null,null,null,null,null,"Economic Definitions"]
[]
[null,null,null,null,null,"This sheet contains all definitions of the economic classification found on the template. The definitions are hyperlinked from the sheets being completed. These definitions assist in determining how to correctly classify each financial item ."]
[]
[null,null,null,null,null,"G&S Definitions:"]
[null,null,null,null,null,"The worksheet provides explanations and examples of the various expenditure items that should be classified under different  goods and services items."]
[]
[null,null,null,null,null,"The Purple Tabs - financial data sheets"]
[]
[null,null,null,null,null,"To note from this part onwards is that the Statement of Financial Performance is broken down into different sheets. Admin sheet and numbers 2 to 10 sheets are what is now called objectives of the entity and this is where the expenses part of the Statement of Financial Performance sheet is reflected.  These sheets contain the Performance Indicators tables.  Detail of the split is below:"]
[]
[null,null,null,null,null,"Revenue"]
[]
[null,null,null,null,null,"The Revenue sheet is the normal income part of the Statement of financial perfomance and has been separated from the expenditure part. Note the check at the bottom of the sheet that checks the surplus/deficit line of what the total revenue less the total expenditure will be against what is in the Annual Report.  The blue shaded areas are still the areas to be completed and not the white ones."]
[]
[null,null,null,null,null,"Admin"]
[]
[null,null,null,null,null,"Admin sheet is what can also be called objective 1 of the entity.  This sheet should be used to capture only the information relating to the Administration Objective of the entity.  The Administration objective should include the following:\n\nEntity Management which includes the salary, allowances and other support costs of the Board and the CEO and the management of the CEO’s office and the Board. \nCorporate Services that include all costs related to staff in the Human Resources, Legal Services, Communications, Information Technology and Other support services (based on the entity’s decision).\nFinance Administration which are all costs related to staff in Finance including the CFO and the management of the Office of the Chief Financial Officer. \nInternal Audit recognising that the reporting channel for the Head of Internal Audit is not through the CFO but directly to the CEO.\nOffice Accommodation which includes activities and costs relating to the provision of office accommodation functions for the entity. Where office accommodation functions relating to other specific objectives of the entity can be identified, they should be assigned to the relevant objective.\nResidential accommodation that includes activities and costs relating to the provision of housing to employees of the entity. (Note: This does not include the residential benefits of the Accounting Authority).\n                                                          \nSource: Guidelines on Budget Programmes (National Treasury. 2010.) Content has been amended to suit public entities"]
[]
[null,null,null,null,null,"The first table to complete on this sheet is the Performance Indicators  table.  The performance indicators to be completed on this table are only those that relate to the Administration Objective of the entity.  The entity should remember to select whether it will like the indicators to be included in the Pub Table or not.  The second table that follows is the detail of the expenditure that relates to the Admin objective broken down into economic classification. The entity should then reflect all expenses relating to the Admin objective and the total for all other objectives should balance to the total expenditure of the objective."]
[null,null,null,null,null,"New performance indicators to the APPs and changes to old performance indicators must be communicated with the budget examiners before they are included for the purposes of this template."]
[null,null,null,null,null,"Objectives 2, 3, 4 .... 10"]
[null,null,null,null,null," "]
[null,null,null,null,null,"Objectives 2 to 10 are sheets exactly the same as the Admin sheet. These should contain the other objectives/activities of the entity on rows 37 of each objective, followed by the Performance Indicators. Relevant balances should be made in each. "]
[null,null,null,null,null,"Cash Flow"]
[]
[null,null,null,null,null,"The Cash Flow Sheet  reflects the Direct Method of the cash flow.  However, this method is more detailed than as shown on the Annual Report. The sheet will be prepopulated with available data and the entity should provide a breakdown of it's operating cash flow activities and should balance to the numbers shown on the Annual Report by checking against the balances on row 195 and 196.  The entity is required to provide this detail fully."]
[]
[null,null,null,null,null,"Financial Position"]
[]
[null,null,null,null,null,"This sheet reflects the assets, liabilities and equity of the entity and the information should balance to the Annual Report in the historical numbers.  The checks on row 99-100 should be used to ensure the balance."]
[]
[null,null,null,null,null,"Related Party Revenue"]
[]
[null,null,null,null,null,"This sheet is to be used to reflect all related party revenue consisting of receipts from sales of goods and services EXCEPT transfer receipts from government institutions. This means that the entity must be doing business with the government institution and receiving payment for such goods and/or services. Transactions with municipalities have been excluded from this sheet because Local Government is not yet included in the government consolidated account. The compiler should use the drop down list to select the relevant categories in this sheet and should refrain from copying the data elsewhere and pasting it on the sheet."]
[null,null,null,null,null,"Please note that the Related Party Revenue sheet is meant to source cash figures. The reported figures should therefore correspond to the Sales by Market Establishment line on the Cash Flow sheet. If for example an entity shows a total of R500 000 for sales by market establishment on the cash flow sheet, the question that should be answered in order to complete this sheet is, how much of the R500 000 is received from other government units (except local government). "]
[null,null,null,null,null,"On column H, the entity is required to indicate the exact transaction that took place resulting into the particular related party revenue. This should be done by selecting a relevant item from the drop down list provided. The question to ask here would be, what exactly did the entity sell to the other government unit that resulted in the receipt of this revenue? eg computer services."]
[]
[null,null,null,null,null,"The personnel sheet should be used to record all costs pertaining to employees of an entity. The guidelines for estimating this sheet are in the main budget guideline. The entity is urged to read through the main guideline as it sets out what the overall budget seeks to address and all the main issues to be considered when compiling budgets over the MTEF. For expenditure on compensation, the total should add up to the total compensation on the ENE Summary. Finance officials together with HR officials should work together to complete this sheet. All blue shaded columns should be completed and the light blue drop down lists used to select the relevant items required."]
[]
[null,null,null,null,null,"DEFINITIONS"]
[null,null,null,null,null,"Approved Establishment refers to the number of employment positions approved by the Entity's Executive Authority."]
[null,null,null,null,null,"Funded Establishment refers to the number of employment positions for which provision is made in the budget."]
[null,null,null,null,null,"Permanent refers to employees with work contracts of unlimited duration."]
[null,null,null,null,null,"Temporary/Contract refers to employees who are employed for a fixed period of time (e.g. 6 months, 2 years, etc.)"]
[null,null,null,null,null,"Guaranteed Package refers to the total of fixed and regular income/benefit items and employer contributions (if any) to Employee Benefit Funds (Retirement, Medical and Group Life). (i.e., Fixed Pay)"]
[null,null,null,null,null,"Performance Bonus refers to the additional compensation paid to an employee for performance that has exceeded expectations. This is typically awarded after a performance appraisal and analysis of projects completed by the employee over a specific period of time. (i.e., Variable Pay)"]
[null,null,null,null,null,"Other (components of remuneration) refers to the Total Cost to Company less Guaranteed Package less Performance Bonus. E.g. overtime payments (i.e., Variable Pay)"]
[]
[null,null,null,null,null,"STEPS TO BE FOLLOWED"]
[null,null,null,null,null,"Column F (Category) - Select the relevant option (whether permanent or temporary/contract - as per definitions above) for a certain group of employees belonging to the salary level in Column H."]
[null,null,null,null,null,"Column G (Salary Level) - Select the relevant salary level starting with the lowest. DO NOT ADD OR DELETE ANY INFORMATION IN THIS COLUMN."]
[null,null,null,null,null,"Column I (Occupation) - Select the occupation which best describes the officials in the salary level that you have selected. The intention is to see the type of skills that the organisation has and not necessarily the functional job titles of individual employees. If none is relevant, then specify the relevant occupation by typing it in."]
[null,null,null,null,null,"Column J (Components of Remuneration) - Select the relevant component of remuneration, starting with the Guaranteed Package followed by the Performance Bonus and then Other (as per definitions above). DO NOT ADD OR DELETE ANY INFORMATION IN THIS COLUMN."]
[null,null,null,null,null,"Column K (Number of posts filled on funded establishment) - Include only the number of posts that were filled and funded on the approved establishment."]
[null,null,null,null,null,"Column L (Expenditure on posts filled on funded establishment) - Include the expenditure on the above-mentioned posts."]
[null,null,null,null,null,"Column M (Unit costs) - Unit costs of the above-mentioned posts. This column is formula driven."]
[null,null,null,null,null,"Column N (Number of posts on approved establishment) – This includes both filled and vacant posts and may or may not be funded. This is as approved by the Entity’s Executive Authority."]
[null,null,null,null,null,"Column O (Number of funded posts (establishment)) – This is a projection from April 2019 to end of March 2020 and includes both filled and vacant posts which are funded."]
[null,null,null,null,null,"Column P (Number of posts filled on funded establishment) - This is a projection of posts that will be filled by the end of March 2020 on the funded establishment."]
[null,null,null,null,null,"Column Q (Expenditure on posts filled on funded establishment) - Expenditure on the above-mentioned posts."]
[null,null,null,null,null,"Column R (Unit costs) - Unit costs of the above-mentioned posts. This column is formula driven."]
[null,null,null,null,null,"Columns S to AA - Projections over the MTEF."]
[]
[null,null,null,null,null,"Check line: "]
[null,null,null,null,null,"All figures must be rounded to the nearest thousand and there should be no decimals. Ensure that the CHECK row shows a dash for each of the financial years. If not, look for errors in the captured data - there may be decimals in the figures or some other error."]
[]
[null,null,null,null,null,"Expend Summary"]
[]
[null,null,null,null,null,"The Expenditure summary sheet is formula driven and contains all expenditures from all 10 objectives that the entity would have completed. This is where the entity can verify if its budget is allocated appropriately in the different objectives to sum the total budget allocated and also to check the status of its expenditure in total.  All the red checks should balance and where they don't, reference should be made back to the individual objectives to check where the problem could be arising from."]
[]
[null,null,null,null,null,"ENE Summary"]
[]
[null,null,null,null,null,"The ENE Summary is what is used to be called the Pub Table.  This sheet summarises all inputs from different sheets in preparation for publication.  The first table is where the different objectives are summarised and the check on row 23 checks that the total objectives equals the total expenditure on row 51.  The second table is the Statement of Financial Performance having combined the inputs in the Revenue sheet and those in the 10 objectives to complete the statement. The next two tables are of the summary of  Cash flow statement and the Financial Position statement as have been completed on their respective sheets.  The final table is that which shows the financial performance of the entity by means of ratios.  This indicates well how the entity is performing over the years."]
[null,null,null,null,null," "]
[null,null,null,null,null,"Perform Info Pub"]
[]
[null,null,null,null,null,"The Performance Information Pub sheet is formula-driven and summarises all the performance indicators reflected on the different objectives.  This sheet will only reflect those indicators that the entity chose to include when completing columns Q of each objective.  This is usually the table that gets published on the ENE publication and reflects the final indicators of the entity."]
[]
[null,null,null,null,null,"Personnel Pub"]
[]
[null,null,null,null,null,"This sheet is formula-driven and summarises the personnel information that is included in the Personnel sheet for publication."]
[]
[null,null,null,null,null,"Personnel Trends"]
[]
[null,null,null,null,null,"Personnel trends with percentage increases and decreases above 10% for headcounts and above 8% increases and decreases for Unit costs must be explained in the trends explaination column (Column O) of the same sheet."]
[]
[null,null,null,null,null,"Checks"]
[]
[null,null,null,null,null,"This sheet should be visited once all has been completed to check and verify that all checks built on the template have been balanced.  It highlights any area where a check should have been balanced  in a specific sheet and in a case where a check is not balanced, the compiler needs to re-visit the specific sheet and correct the errors so as to balance the checks.  Should an entity submit the templates with any of the checks unbalanced, a query will be raised.  The entity is urged to attend to all checks in the template and ensure that there are no checks not balancing."]
[]
[null,null,null,null,null,"The Red Tabs - formula-driven sheets for analysis "]
[null,null,null,null,null,"Trends Analysis "]
[]
[null,null,null,null,null,"The sheet contains growth trends. The entity will need to pay attention to and explain on the financial perfomance and cash flow explanation tables provided on the sheet where highlighted by a certain colour.  There is a legend that explains the different colours that will be highlighted once a certain concerning trend is reflected.  A trend will be concerning if, for an example, a certain goods and services item is increasing or decreasing at a rate different from the average. The entities are urged to peruse this sheet carefully to monitor the trends in their budget submissions."]
[]
[null,null,null,null,null,"Cash flow differences"]
[]
[null,null,null,null,null,"The sheet reflects differences between the figures in the current budget process and the ones in the previous year's budget process. There is a legend that explains the different colours that will be highlighted once a certain concerning trend is reflected. There is an explanation table provided for entities to give reasons for changes."]
[]
[null,null,null,null,null,"The Green Tabs - additional financial information on Infrastructure and ODA"]
[]
[null,null,null,null,null,"Infrastructure"]
[]
[null,null,null,null,null,"This sheet is to be completed only by entities that are involved in infrastructure projects.  The project name, description, stage, cost and all other required information should be provided to ensure completeness. The sheet is prepopulated with last years numbers. "]
[]
[null,null,null,null,null,"When done completing the budget template"]
[]
[null,null,null,null,null,"Go back to the Information sheet."]
[null,null,null,null,null,"Print out the sign off page,  sign on the signature space, scan and email the document along with the budget planning baseline tool ."]